
<%@page import="java.util.ArrayList"%>
<%@page import="classes.Reports"%>
<form action="stocktype.html">
    <table>
            <tr><td><font>Stock Type&nbsp;&nbsp;</font></td><td> <select name="stock">
            <% 
            Reports.getConnection("SELECT * FROM brchung.stock group by type;");
            ArrayList<String[]> rs=Reports.getResults(3);
            for(int i=0;i<rs.size();i++)
            {
                out.println("<option value=\""+rs.get(i)[0] +"\">"+rs.get(i)[0] +"</option>");
            }
            %>
                    </select><br/></td></tr><tr><td>&nbsp;</td></tr>
        
    </table>
    <input type="submit" Value="Submit"/>
</form>